Charting on Cross-Tab summaries (Cross-Tab layout)
Crystal Reports allows you to include a chart based on summary values in your Cross-Tab report. For example, with a Cross-Tab that shows the amount of a certain product sold in each region of the United States, you may want to include a chart showing the percentage of total sales provided by each region for that product.
To create a Cross-Tab chart, you must first have a Cross-Tab in your report. For more information, see Cross-Tab Objects.
To chart on a Cross-Tab summary
- Select the Cross-Tab on which you want to chart.
- On the Insert menu, click Chart. The Chart Expert dialog box appears.
Tip:
Another way to do this is to click the Insert Chart button on the Standard toolbar.
- On the Type tab, in the Chart type list, select a chart type. Then click the chart subtype that best illustrates your data. See Chart types.
- Select Automatically set chart options if you want the Chart Expert to use the default options on the Axes and Options tabs.
Note: If you want to select options on the Axes and Options tabs manually, ensure that "Automatically set chart options" is not selected.
- Click the Data tab.
- In the Layout area, click Cross-Tab, if it is not already selected.
- In the Placement area, click Header or Footer to specify where to place your chart.
Note: How often your chart appears on the report depends on where the Cross-Tab summary field has been placed.
- In the Data area, in the On change of list, click the group field you want to base your chart on.
- If necessary, in the Subdivided by list, click a secondary row or column you want to base your chart on.
- In the Show list, click the summary field you want to display on your chart.
- If the Axes and Options tabs appear, you can customize some of the chart's properties, such as the scaling of the axes, the legend, and the data points.
- Click the Text tab.
- Accept the default title information or add new titles to your chart.
- Click OK.
Your chart is placed in the Header or Footer section of the report, depending on your selection in Step 7. You may have to refresh your report to preview the finished chart.
Note: When your chart is inserted, it may cover a portion of the report. Move and resize the chart so that it fits properly within the report.